package com.gm.springboot.mapper;

import com.gm.springboot.bean.GalGame;
import com.gm.springboot.bean.Major;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

/**
 * @Author Administrator
 * @Date 2020/7/2 17:25
 **/
public interface GalgameMapper {
    @Select("select * from galGame")
    List<GalGame> findGalGameAll();
    @Delete("delete from galGame where galid=#{galid}")
    int delGalGame(Integer galid);
    @Insert("insert into galGame(galname,galprice,galdevelopers) values(#{galname},#{galprice},#{galdevelopers})")
    int addGalGame(GalGame galGame);
    @Select("select * from galGame where galid=#{galid}")
    GalGame findGalGameById(Integer galid);
    @Update("update galGame set galname=#{galname},galprice=#{galprice},galdevelopers=#{galdevelopers} where galid=#{galid}")
    int updGalGame(GalGame galGame);
}
